<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html 
     PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
     "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>
<head>
  <title>find_cols_types (DB_Table)</title>
  <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
  <link rel="stylesheet" href="../.././rdoc-style.css" type="text/css" media="screen" />
</head>
<body class="standalone-code">
  <pre><span class="ruby-comment cmt"># File lib/DB_Table.rb, line 94</span>
  <span class="ruby-keyword kw">def</span> <span class="ruby-identifier">find_cols_types</span>
    <span class="ruby-comment cmt">#getting column names</span>
    <span class="ruby-identifier">curS</span> = <span class="ruby-ivar">@lines</span>[<span class="ruby-ivar">@strtTblNm</span> <span class="ruby-operator">+</span> <span class="ruby-ivar">@tblNmLngth</span>, <span class="ruby-ivar">@lines</span>.<span class="ruby-identifier">length</span>]
    
    <span class="ruby-identifier">intv</span> = <span class="ruby-value">0</span>
    <span class="ruby-identifier">after1st</span> = <span class="ruby-keyword kw">false</span>
    <span class="ruby-identifier">lastCol</span> = <span class="ruby-keyword kw">false</span>
    <span class="ruby-identifier">nxt</span> = <span class="ruby-value str">&quot;c&quot;</span>
    <span class="ruby-identifier">done</span> = <span class="ruby-keyword kw">false</span>
    
    <span class="ruby-keyword kw">while</span> <span class="ruby-identifier">done</span> <span class="ruby-operator">==</span> <span class="ruby-keyword kw">false</span>
      <span class="ruby-keyword kw">if</span> <span class="ruby-identifier">nxt</span> <span class="ruby-operator">==</span> <span class="ruby-value str">&quot;c&quot;</span> <span class="ruby-keyword kw">then</span>      <span class="ruby-comment cmt">#looking for column?</span>
         <span class="ruby-keyword kw">if</span> <span class="ruby-identifier">after1st</span> <span class="ruby-operator">==</span> <span class="ruby-keyword kw">false</span> <span class="ruby-keyword kw">then</span>       <span class="ruby-comment cmt">#is this the first column?</span>
           <span class="ruby-identifier">curS</span> = <span class="ruby-identifier">curS</span>[ <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">index</span>( <span class="ruby-value str">&quot;(&quot;</span> ) <span class="ruby-operator">+</span> <span class="ruby-value">1</span> , <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">length</span> ]
           <span class="ruby-identifier">after1st</span> = <span class="ruby-keyword kw">true</span>
         <span class="ruby-keyword kw">else</span>
           <span class="ruby-identifier">curS</span> = <span class="ruby-identifier">curS</span>[ <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">index</span>( <span class="ruby-value str">&quot;,&quot;</span> ) <span class="ruby-operator">+</span> <span class="ruby-value">1</span> , <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">length</span> ]
           <span class="ruby-identifier">done</span> <span class="ruby-operator">==</span> <span class="ruby-keyword kw">true</span>
         <span class="ruby-keyword kw">end</span>
         <span class="ruby-identifier">curS</span> = <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">strip</span>
         <span class="ruby-identifier">curS</span> = <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">strip</span>
         <span class="ruby-identifier">intv</span> = <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">index</span>( <span class="ruby-value str">&quot; &quot;</span> )
         <span class="ruby-ivar">@colNames</span>.<span class="ruby-identifier">push</span>( <span class="ruby-identifier">curS</span>[ <span class="ruby-value">0</span>, <span class="ruby-identifier">intv</span> ] )
         <span class="ruby-identifier">nxt</span> = <span class="ruby-value str">&quot;t&quot;</span>
         <span class="ruby-identifier">curS</span> = <span class="ruby-identifier">curS</span>[ <span class="ruby-identifier">intv</span>, <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">length</span> ]
      <span class="ruby-keyword kw">elsif</span> <span class="ruby-identifier">nxt</span> <span class="ruby-operator">==</span> <span class="ruby-value str">&quot;t&quot;</span> <span class="ruby-keyword kw">then</span>  <span class="ruby-comment cmt">#looking for data  type?</span>
         <span class="ruby-identifier">curS</span> = <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">strip</span>
         <span class="ruby-identifier">intv</span> = <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">index</span>( <span class="ruby-value str">&quot;,&quot;</span> )
         <span class="ruby-keyword kw">if</span> <span class="ruby-keyword kw">not</span> <span class="ruby-identifier">intv</span>.<span class="ruby-identifier">nil?</span> <span class="ruby-keyword kw">then</span>
           <span class="ruby-ivar">@colDTypes</span>.<span class="ruby-identifier">push</span>( <span class="ruby-identifier">curS</span>[ <span class="ruby-value">0</span>, <span class="ruby-identifier">intv</span> ] )
           <span class="ruby-identifier">curS</span> = <span class="ruby-identifier">curS</span>[ <span class="ruby-identifier">intv</span>, <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">length</span> ]
         <span class="ruby-keyword kw">else</span>
           <span class="ruby-identifier">done</span> = <span class="ruby-keyword kw">true</span>
           <span class="ruby-identifier">curS</span> = <span class="ruby-identifier">curS</span>[ <span class="ruby-value">0</span>, <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">index</span>( <span class="ruby-value str">&quot;)&quot;</span> ) ]
           <span class="ruby-identifier">curS</span> = <span class="ruby-identifier">curS</span>.<span class="ruby-identifier">strip</span>
           <span class="ruby-ivar">@colDTypes</span>.<span class="ruby-identifier">push</span>( <span class="ruby-identifier">curS</span> )
         <span class="ruby-keyword kw">end</span>
         <span class="ruby-identifier">nxt</span> = <span class="ruby-value str">&quot;c&quot;</span>
      <span class="ruby-keyword kw">end</span>   
    <span class="ruby-keyword kw">end</span> <span class="ruby-comment cmt">#end while</span>
  <span class="ruby-keyword kw">end</span></pre>
</body>
</html>